﻿CREATE TABLE [dbo].[ProjectBlock] (
    [Id]               INT          IDENTITY (1, 1) NOT NULL,
    [ProjectId]        INT          NOT NULL,
    [BlockNo]          NVARCHAR (5) NOT NULL,
    [DoorPlateBlockNo] NVARCHAR (5) NULL,
    CONSTRAINT [PK_ProjectBlock] PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK_ProjectBlock_Project] FOREIGN KEY ([ProjectId]) REFERENCES [dbo].[Project] ([Id])
);

